﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="lanets2011" targetNamespace="http://tempuri.org/lanets2011.xsd" xmlns:mstns="http://tempuri.org/lanets2011.xsd" xmlns="http://tempuri.org/lanets2011.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="lan2011ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="lan2011ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.LanSoft.Properties.Settings.GlobalReference.Default.lan2011ConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="usersTableAdapter" GeneratorDataComponentClassName="usersTableAdapter" Name="users" UserDataComponentName="usersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `users` WHERE ((`id` = @Original_id) AND (`first_name` = @Original_first_name) AND (`last_name` = @Original_last_name) AND (`gender` = @Original_gender) AND (`birthday` = @Original_birthday) AND (`nickname` = @Original_nickname) AND (`password` = @Original_password) AND (`email` = @Original_email) AND (`banned` = @Original_banned) AND (`id_group` = @Original_id_group) AND (`lang` = @Original_lang) AND (`join_timestamp` = @Original_join_timestamp) AND (`red_flags` = @Original_red_flags) AND (`numPosts` = @Original_numPosts) AND (`last_post_timestamp` = @Original_last_post_timestamp) AND (`paid_timestamp` = @Original_paid_timestamp) AND (`last_conn_timestamp` = @Original_last_conn_timestamp) AND (`checkin_timestamp` = @Original_checkin_timestamp) AND (`termsaccept_timestamp` = @Original_termsaccept_timestamp) AND (`id_sponsor` = @Original_id_sponsor) AND (`confirmed` = @Original_confirmed) AND (`rand_conf` = @Original_rand_conf) AND (`tournament_id` = @Original_tournament_id) AND (`clan_name` = @Original_clan_name) AND (`is_volunteer` = @Original_is_volunteer))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_gender" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_birthday" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="birthday" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nickname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_banned" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="banned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_group" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_group" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lang" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_join_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="join_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_red_flags" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="red_flags" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numPosts" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="numPosts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_last_post_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="last_post_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_paid_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="paid_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_last_conn_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="last_conn_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_checkin_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="checkin_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_termsaccept_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="termsaccept_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_sponsor" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_sponsor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_confirmed" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="confirmed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rand_conf" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rand_conf" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tournament_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tournament_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_clan_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="clan_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_is_volunteer" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="is_volunteer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT id, first_name, last_name, gender, birthday, nickname, password, email, banned, id_group, lang, join_timestamp, avatar_url, red_flags, numPosts, last_post_timestamp, paid_timestamp, last_conn_timestamp, checkin_timestamp, termsaccept_timestamp, id_sponsor, commentaires, confirmed, rand_conf, tournament_id, clan_name, is_volunteer FROM users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `users` SET `first_name` = @first_name, `last_name` = @last_name, `gender` = @gender, `birthday` = @birthday, `nickname` = @nickname, `password` = @password, `email` = @email, `banned` = @banned, `id_group` = @id_group, `lang` = @lang, `join_timestamp` = @join_timestamp, `avatar_url` = @avatar_url, `red_flags` = @red_flags, `numPosts` = @numPosts, `last_post_timestamp` = @last_post_timestamp, `paid_timestamp` = @paid_timestamp, `last_conn_timestamp` = @last_conn_timestamp, `checkin_timestamp` = @checkin_timestamp, `termsaccept_timestamp` = @termsaccept_timestamp, `id_sponsor` = @id_sponsor, `commentaires` = @commentaires, `confirmed` = @confirmed, `rand_conf` = @rand_conf, `tournament_id` = @tournament_id, `clan_name` = @clan_name, `is_volunteer` = @is_volunteer WHERE ((`id` = @Original_id) AND (`first_name` = @Original_first_name) AND (`last_name` = @Original_last_name) AND (`gender` = @Original_gender) AND (`birthday` = @Original_birthday) AND (`nickname` = @Original_nickname) AND (`password` = @Original_password) AND (`email` = @Original_email) AND (`banned` = @Original_banned) AND (`id_group` = @Original_id_group) AND (`lang` = @Original_lang) AND (`join_timestamp` = @Original_join_timestamp) AND (`red_flags` = @Original_red_flags) AND (`numPosts` = @Original_numPosts) AND (`last_post_timestamp` = @Original_last_post_timestamp) AND (`paid_timestamp` = @Original_paid_timestamp) AND (`last_conn_timestamp` = @Original_last_conn_timestamp) AND (`checkin_timestamp` = @Original_checkin_timestamp) AND (`termsaccept_timestamp` = @Original_termsaccept_timestamp) AND (`id_sponsor` = @Original_id_sponsor) AND (`confirmed` = @Original_confirmed) AND (`rand_conf` = @Original_rand_conf) AND (`tournament_id` = @Original_tournament_id) AND (`clan_name` = @Original_clan_name) AND (`is_volunteer` = @Original_is_volunteer))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@gender" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@birthday" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="birthday" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nickname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@banned" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="banned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_group" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_group" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@lang" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@join_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="join_timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@avatar_url" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="avatar_url" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@red_flags" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="red_flags" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numPosts" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="numPosts" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@last_post_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="last_post_timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@paid_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="paid_timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@last_conn_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="last_conn_timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@checkin_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="checkin_timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@termsaccept_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="termsaccept_timestamp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_sponsor" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_sponsor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@commentaires" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="commentaires" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@confirmed" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="confirmed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rand_conf" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rand_conf" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tournament_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tournament_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@clan_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="clan_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@is_volunteer" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="is_volunteer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_first_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="first_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_last_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="last_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_gender" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_birthday" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="birthday" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nickname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nickname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_banned" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="banned" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_group" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_group" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_lang" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="lang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_join_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="join_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_red_flags" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="red_flags" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numPosts" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="numPosts" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_last_post_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="last_post_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_paid_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="paid_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_last_conn_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="last_conn_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_checkin_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="checkin_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_termsaccept_timestamp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="termsaccept_timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_sponsor" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_sponsor" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_confirmed" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="confirmed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rand_conf" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="rand_conf" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tournament_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tournament_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_clan_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="clan_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_is_volunteer" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="is_volunteer" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="first_name" DataSetColumn="first_name" />
              <Mapping SourceColumn="last_name" DataSetColumn="last_name" />
              <Mapping SourceColumn="gender" DataSetColumn="gender" />
              <Mapping SourceColumn="birthday" DataSetColumn="birthday" />
              <Mapping SourceColumn="nickname" DataSetColumn="nickname" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="banned" DataSetColumn="banned" />
              <Mapping SourceColumn="id_group" DataSetColumn="id_group" />
              <Mapping SourceColumn="lang" DataSetColumn="lang" />
              <Mapping SourceColumn="join_timestamp" DataSetColumn="join_timestamp" />
              <Mapping SourceColumn="avatar_url" DataSetColumn="avatar_url" />
              <Mapping SourceColumn="red_flags" DataSetColumn="red_flags" />
              <Mapping SourceColumn="numPosts" DataSetColumn="numPosts" />
              <Mapping SourceColumn="last_post_timestamp" DataSetColumn="last_post_timestamp" />
              <Mapping SourceColumn="paid_timestamp" DataSetColumn="paid_timestamp" />
              <Mapping SourceColumn="last_conn_timestamp" DataSetColumn="last_conn_timestamp" />
              <Mapping SourceColumn="id_sponsor" DataSetColumn="id_sponsor" />
              <Mapping SourceColumn="commentaires" DataSetColumn="commentaires" />
              <Mapping SourceColumn="confirmed" DataSetColumn="confirmed" />
              <Mapping SourceColumn="rand_conf" DataSetColumn="rand_conf" />
              <Mapping SourceColumn="tournament_id" DataSetColumn="tournament_id" />
              <Mapping SourceColumn="clan_name" DataSetColumn="clan_name" />
              <Mapping SourceColumn="checkin_timestamp" DataSetColumn="checkin_timestamp" />
              <Mapping SourceColumn="termsaccept_timestamp" DataSetColumn="termsaccept_timestamp" />
              <Mapping SourceColumn="is_volunteer" DataSetColumn="is_volunteer" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT avatar_url, banned, birthday, checkin_timestamp, clan_name, commentaires, confirmed, email, first_name, gender, id, id_group, id_sponsor, is_volunteer, join_timestamp, lang, 
                  last_conn_timestamp, last_name, last_post_timestamp, nickname, numPosts, paid_timestamp, password, rand_conf, red_flags, termsaccept_timestamp, tournament_id
FROM     users
WHERE  (LOWER(id) LIKE LOWER(@search)) OR
                  (LOWER(first_name) LIKE LOWER(@search)) OR
                  (LOWER(last_name) LIKE LOWER(@search)) OR
                  (LOWER(nickname) LIKE LOWER(@search)) OR
                  (LOWER(email) LIKE LOWER(@search)) OR
                  (LOWER(clan_name) LIKE LOWER(@search))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="search" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@search" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT avatar_url, banned, birthday, checkin_timestamp, clan_name, commentaires, confirmed, email, first_name, gender, id, id_group, id_sponsor, is_volunteer, join_timestamp, lang, last_conn_timestamp, last_name, last_post_timestamp, nickname, numPosts, paid_timestamp, password, rand_conf, red_flags, termsaccept_timestamp, tournament_id FROM users WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="lan2011.users" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetNom" Modifier="Public" Name="GetNom" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetNom">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT CONCAT(first_name, ' ', last_name) AS Name
FROM     users
WHERE  (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="lan2011.users" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="groupsTableAdapter" GeneratorDataComponentClassName="groupsTableAdapter" Name="groups" UserDataComponentName="groupsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.groups" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `groups` WHERE ((`id` = @Original_id) AND (`title_en` = @Original_title_en) AND (`title_fr` = @Original_title_fr))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title_en" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_en" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title_fr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_fr" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `groups` (`title_en`, `title_fr`) VALUES (@title_en, @title_fr)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title_en" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title_fr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_fr" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `groups`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `groups` SET `title_en` = @title_en, `title_fr` = @title_fr WHERE ((`id` = @Original_id) AND (`title_en` = @Original_title_en) AND (`title_fr` = @Original_title_fr))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title_en" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_en" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title_fr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_fr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title_en" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_en" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title_fr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title_fr" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title_en" DataSetColumn="title_en" />
              <Mapping SourceColumn="title_fr" DataSetColumn="title_fr" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="seatreferencesTableAdapter" GeneratorDataComponentClassName="seatreferencesTableAdapter" Name="seatreferences" UserDataComponentName="seatreferencesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.seatreference" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `seatreference` WHERE ((`seatId` = @Original_seatId) AND (`Reference` = @Original_Reference))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_seatId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seatId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Reference" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reference" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `seatreference` (`seatId`, `Reference`) VALUES (@seatId, @Reference)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@seatId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seatId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Reference" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reference" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `seatreference`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `seatreference` SET `seatId` = @seatId, `Reference` = @Reference WHERE ((`seatId` = @Original_seatId) AND (`Reference` = @Original_Reference))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@seatId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seatId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Reference" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reference" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_seatId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seatId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Reference" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Reference" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="seatId" DataSetColumn="seatId" />
              <Mapping SourceColumn="Reference" DataSetColumn="Reference" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.seatreference" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySeatId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySeatId" GeneratorSourceName="FillBySeatId" GetMethodModifier="Public" GetMethodName="GetDataBySeatId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySeatId" UserSourceName="FillBySeatId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT seatId, Reference
FROM     seatreference
WHERE  (seatId = @seatid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="seatid" ColumnName="seatId" DataSourceName="lan2011.seatreference" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@seatid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seatId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="seatreservationsTableAdapter" GeneratorDataComponentClassName="seatreservationsTableAdapter" Name="seatreservations" UserDataComponentName="seatreservationsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.seatreservations" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `seatreservations` (`seatId`, `userId`, `DateTaken`, `Hidden`) VALUES (@seatId, @userId, @DateTaken, @Hidden)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@seatId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="seatId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateTaken" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="DateTaken" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Hidden" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="Hidden" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `seatreservations`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="seatId" DataSetColumn="seatId" />
              <Mapping SourceColumn="userId" DataSetColumn="userId" />
              <Mapping SourceColumn="DateTaken" DataSetColumn="DateTaken" />
              <Mapping SourceColumn="Hidden" DataSetColumn="Hidden" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.seatreservations" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserId" GeneratorSourceName="FillByUserId" GetMethodModifier="Public" GetMethodName="GetDataByUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserId" UserSourceName="FillByUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT seatId, userId, DateTaken, Hidden
FROM     seatreservations
WHERE  (userId = @userid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="userid" ColumnName="userId" DataSourceName="lan2011.seatreservations" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@userid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="userId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ticketsTableAdapter" GeneratorDataComponentClassName="ticketsTableAdapter" Name="tickets" UserDataComponentName="ticketsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `tickets` WHERE ((`id` = @Original_id) AND (`user_id` = @Original_user_id) AND (`type` = @Original_type) AND (`txn_id` = @Original_txn_id) AND (`paid` = @Original_paid))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_paid" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `tickets` (`user_id`, `type`, `txn_id`, `paid`) VALUES (@user_id, @type, @txn_id, @paid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@type" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@paid" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `tickets`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `tickets` SET `user_id` = @user_id, `type` = @type, `txn_id` = @txn_id, `paid` = @paid WHERE ((`id` = @Original_id) AND (`user_id` = @Original_user_id) AND (`type` = @Original_type) AND (`txn_id` = @Original_txn_id) AND (`paid` = @Original_paid))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@type" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@paid" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="SByte" Direction="Input" ParameterName="@Original_paid" Precision="0" ProviderType="Byte" Scale="0" Size="0" SourceColumn="paid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="txn_id" DataSetColumn="txn_id" />
              <Mapping SourceColumn="paid" DataSetColumn="paid" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById" GeneratorSourceName="FillById" GetMethodModifier="Public" GetMethodName="GetDataById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById" UserSourceName="FillById">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT id, user_id, type, txn_id, paid
FROM     tickets
WHERE  (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="lan2011.tickets" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTxnId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTxnId" GeneratorSourceName="FillByTxnId" GetMethodModifier="Public" GetMethodName="GetDataByTxnId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTxnId" UserSourceName="FillByTxnId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT id, user_id, type, txn_id, paid, commentaires
FROM     tickets
WHERE  (txn_id = @txnid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="txnid" ColumnName="txn_id" DataSourceName="lan2011.tickets" DataTypeServer="varchar(255)(255)" DbType="String" Direction="Input" ParameterName="@txnid" Precision="0" ProviderType="VarChar" Scale="0" Size="255" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.tickets" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserId" GeneratorSourceName="FillByUserId" GetMethodModifier="Public" GetMethodName="GetDataByUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserId" UserSourceName="FillByUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT id, user_id, type, txn_id, paid, commentaires
FROM     tickets
WHERE  (user_id = @userid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userid" ColumnName="user_id" DataSourceName="lan2011.tickets" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@userid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="transactionsTableAdapter" GeneratorDataComponentClassName="transactionsTableAdapter" Name="transactions" UserDataComponentName="transactionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.transactions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `transactions` WHERE ((`id` = @Original_id) AND (`txn_id` = @Original_txn_id) AND (`user_id` = @Original_user_id) AND (`description` = @Original_description) AND (`state` = @Original_state) AND (`pp_txn_id` = @Original_pp_txn_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pp_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pp_txn_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `transactions` (`txn_id`, `user_id`, `description`, `state`, `pp_txn_id`) VALUES (@txn_id, @user_id, @description, @state, @pp_txn_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pp_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pp_txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `transactions`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `transactions` SET `txn_id` = @txn_id, `user_id` = @user_id, `description` = @description, `state` = @state, `pp_txn_id` = @pp_txn_id WHERE ((`id` = @Original_id) AND (`txn_id` = @Original_txn_id) AND (`user_id` = @Original_user_id) AND (`description` = @Original_description) AND (`state` = @Original_state) AND (`pp_txn_id` = @Original_pp_txn_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@state" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pp_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pp_txn_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="txn_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_state" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="state" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_pp_txn_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="pp_txn_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="txn_id" DataSetColumn="txn_id" />
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="state" DataSetColumn="state" />
              <Mapping SourceColumn="pp_txn_id" DataSetColumn="pp_txn_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.transactions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserId" GeneratorSourceName="FillByUserId" GetMethodModifier="Public" GetMethodName="GetDataByUserId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserId" UserSourceName="FillByUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT id, txn_id, user_id, description, state, pp_txn_id
FROM     transactions
WHERE  (user_id = @userid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userid" ColumnName="user_id" DataSourceName="lan2011.transactions" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@userid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="actionsTableAdapter" GeneratorDataComponentClassName="actionsTableAdapter" Name="actions" UserDataComponentName="actionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.dortoirs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `dortoirs` (`user_id`, `date_action`, `action`, `commentaires`) VALUES (@user_id, @date_action, @action, @commentaires)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_action" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@commentaires" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="commentaires" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT * FROM `dortoirs`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="date_action" DataSetColumn="date_action" />
              <Mapping SourceColumn="action" DataSetColumn="action" />
              <Mapping SourceColumn="commentaires" DataSetColumn="commentaires" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="CountDortoir" Modifier="Public" Name="CountDortoir" QueryType="Scalar" ScalarCallRetval="System.Int64, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="CountDortoir">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT (SELECT COUNT(*) FROM dortoirs WHERE Action = "Entrée") - (SELECT COUNT(*) FROM dortoirs WHERE Action = "Sortie") AS Participants</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteId" Modifier="Public" Name="DeleteId" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="DeleteId">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM dortoirs
WHERE  (user_id = @user_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="user_id" ColumnName="user_id" DataSourceName="lan2011.dortoirs" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.dortoirs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySearch" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySearch" GeneratorSourceName="FillBySearch" GetMethodModifier="Public" GetMethodName="GetDataBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySearch" UserSourceName="FillBySearch">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT user_id, date_action, action, commentaires
FROM     dortoirs
WHERE  (commentaires LIKE @search)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="search" ColumnName="commentaires" DataSourceName="lan2011.dortoirs" DataTypeServer="text" DbType="String" Direction="Input" ParameterName="@search" Precision="0" ProviderType="Text" Scale="0" Size="2147483647" SourceColumn="commentaires" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectName="lan2011.dortoirs" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetLastActionFromUser" Modifier="Public" Name="GetLastActionFromUser" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetLastActionFromUser">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT action FROM dortoirs WHERE user_id = @userid AND date_action = (select max(date_action) from dortoirs where user_id = @userid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userid" ColumnName="user_id" DataSourceName="lan2011.dortoirs" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@userid" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="lan2011ConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="IsParticipantDodo" Modifier="Public" Name="IsParticipantDodo" QueryType="Scalar" ScalarCallRetval="System.Int64, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="IsParticipantDodo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT COUNT(user_id) AS Expr1
FROM     dortoirs
WHERE  (user_id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="user_id" DataSourceName="lan2011.dortoirs" DataTypeServer="int(11)" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="lanets2011" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="lanets2011" msprop:Generator_UserDSName="lanets2011">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="users" msprop:Generator_TableClassName="usersDataTable" msprop:Generator_TableVarName="tableusers" msprop:Generator_TablePropName="users" msprop:Generator_RowDeletingName="usersRowDeleting" msprop:Generator_UserTableName="users" msprop:Generator_RowChangingName="usersRowChanging" msprop:Generator_RowEvHandlerName="usersRowChangeEventHandler" msprop:Generator_RowDeletedName="usersRowDeleted" msprop:Generator_RowEvArgName="usersRowChangeEvent" msprop:Generator_RowChangedName="usersRowChanged" msprop:Generator_RowClassName="usersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="first_name" msprop:Generator_ColumnVarNameInTable="columnfirst_name" msprop:Generator_ColumnPropNameInRow="first_name" msprop:Generator_ColumnPropNameInTable="first_nameColumn" msprop:Generator_UserColumnName="first_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="last_name" msprop:Generator_ColumnVarNameInTable="columnlast_name" msprop:Generator_ColumnPropNameInRow="last_name" msprop:Generator_ColumnPropNameInTable="last_nameColumn" msprop:Generator_UserColumnName="last_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gender" msprop:Generator_ColumnVarNameInTable="columngender" msprop:Generator_ColumnPropNameInRow="gender" msprop:Generator_ColumnPropNameInTable="genderColumn" msprop:Generator_UserColumnName="gender" type="xs:int" />
              <xs:element name="birthday" msprop:Generator_ColumnVarNameInTable="columnbirthday" msprop:Generator_ColumnPropNameInRow="birthday" msprop:Generator_ColumnPropNameInTable="birthdayColumn" msprop:Generator_UserColumnName="birthday">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nickname" msprop:Generator_ColumnVarNameInTable="columnnickname" msprop:Generator_ColumnPropNameInRow="nickname" msprop:Generator_ColumnPropNameInTable="nicknameColumn" msprop:Generator_UserColumnName="nickname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="banned" msprop:Generator_ColumnVarNameInTable="columnbanned" msprop:Generator_ColumnPropNameInRow="banned" msprop:Generator_ColumnPropNameInTable="bannedColumn" msprop:Generator_UserColumnName="banned" type="xs:boolean" />
              <xs:element name="id_group" msprop:Generator_ColumnVarNameInTable="columnid_group" msprop:Generator_ColumnPropNameInRow="id_group" msprop:Generator_ColumnPropNameInTable="id_groupColumn" msprop:Generator_UserColumnName="id_group" type="xs:int" />
              <xs:element name="lang" msprop:Generator_ColumnVarNameInTable="columnlang" msprop:Generator_ColumnPropNameInRow="lang" msprop:Generator_ColumnPropNameInTable="langColumn" msprop:Generator_UserColumnName="lang" type="xs:int" />
              <xs:element name="join_timestamp" msprop:Generator_ColumnVarNameInTable="columnjoin_timestamp" msprop:Generator_ColumnPropNameInRow="join_timestamp" msprop:Generator_ColumnPropNameInTable="join_timestampColumn" msprop:Generator_UserColumnName="join_timestamp" type="xs:int" />
              <xs:element name="avatar_url" msprop:Generator_ColumnVarNameInTable="columnavatar_url" msprop:Generator_ColumnPropNameInRow="avatar_url" msprop:Generator_ColumnPropNameInTable="avatar_urlColumn" msprop:Generator_UserColumnName="avatar_url">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5592405" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="red_flags" msprop:Generator_ColumnVarNameInTable="columnred_flags" msprop:Generator_ColumnPropNameInRow="red_flags" msprop:Generator_ColumnPropNameInTable="red_flagsColumn" msprop:Generator_UserColumnName="red_flags" type="xs:int" />
              <xs:element name="numPosts" msprop:Generator_ColumnVarNameInTable="columnnumPosts" msprop:Generator_ColumnPropNameInRow="numPosts" msprop:Generator_ColumnPropNameInTable="numPostsColumn" msprop:Generator_UserColumnName="numPosts" type="xs:int" />
              <xs:element name="last_post_timestamp" msprop:Generator_ColumnVarNameInTable="columnlast_post_timestamp" msprop:Generator_ColumnPropNameInRow="last_post_timestamp" msprop:Generator_ColumnPropNameInTable="last_post_timestampColumn" msprop:Generator_UserColumnName="last_post_timestamp" type="xs:int" />
              <xs:element name="paid_timestamp" msprop:Generator_ColumnVarNameInTable="columnpaid_timestamp" msprop:Generator_ColumnPropNameInRow="paid_timestamp" msprop:Generator_ColumnPropNameInTable="paid_timestampColumn" msprop:Generator_UserColumnName="paid_timestamp" type="xs:int" />
              <xs:element name="last_conn_timestamp" msprop:Generator_ColumnVarNameInTable="columnlast_conn_timestamp" msprop:Generator_ColumnPropNameInRow="last_conn_timestamp" msprop:Generator_ColumnPropNameInTable="last_conn_timestampColumn" msprop:Generator_UserColumnName="last_conn_timestamp" type="xs:int" />
              <xs:element name="id_sponsor" msprop:Generator_ColumnVarNameInTable="columnid_sponsor" msprop:Generator_ColumnPropNameInRow="id_sponsor" msprop:Generator_ColumnPropNameInTable="id_sponsorColumn" msprop:Generator_UserColumnName="id_sponsor" type="xs:int" />
              <xs:element name="commentaires" msprop:Generator_ColumnVarNameInTable="columncommentaires" msprop:Generator_ColumnPropNameInRow="commentaires" msprop:Generator_ColumnPropNameInTable="commentairesColumn" msprop:Generator_UserColumnName="commentaires">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="21845" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="confirmed" msprop:Generator_ColumnVarNameInTable="columnconfirmed" msprop:Generator_ColumnPropNameInRow="confirmed" msprop:Generator_ColumnPropNameInTable="confirmedColumn" msprop:Generator_UserColumnName="confirmed" type="xs:boolean" />
              <xs:element name="rand_conf" msprop:Generator_ColumnVarNameInTable="columnrand_conf" msprop:Generator_ColumnPropNameInRow="rand_conf" msprop:Generator_ColumnPropNameInTable="rand_confColumn" msprop:Generator_UserColumnName="rand_conf">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tournament_id" msprop:Generator_ColumnVarNameInTable="columntournament_id" msprop:Generator_ColumnPropNameInRow="tournament_id" msprop:Generator_ColumnPropNameInTable="tournament_idColumn" msprop:Generator_UserColumnName="tournament_id" type="xs:int" />
              <xs:element name="clan_name" msprop:Generator_ColumnVarNameInTable="columnclan_name" msprop:Generator_ColumnPropNameInRow="clan_name" msprop:Generator_ColumnPropNameInTable="clan_nameColumn" msprop:Generator_UserColumnName="clan_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="checkin_timestamp" msprop:Generator_ColumnVarNameInTable="columncheckin_timestamp" msprop:Generator_ColumnPropNameInRow="checkin_timestamp" msprop:Generator_ColumnPropNameInTable="checkin_timestampColumn" msprop:Generator_UserColumnName="checkin_timestamp" type="xs:int" />
              <xs:element name="termsaccept_timestamp" msprop:Generator_ColumnVarNameInTable="columntermsaccept_timestamp" msprop:Generator_ColumnPropNameInRow="termsaccept_timestamp" msprop:Generator_ColumnPropNameInTable="termsaccept_timestampColumn" msprop:Generator_UserColumnName="termsaccept_timestamp" type="xs:int" />
              <xs:element name="is_volunteer" msprop:Generator_ColumnVarNameInTable="columnis_volunteer" msprop:Generator_ColumnPropNameInRow="is_volunteer" msprop:Generator_ColumnPropNameInTable="is_volunteerColumn" msprop:Generator_UserColumnName="is_volunteer" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="groups" msprop:Generator_TableClassName="groupsDataTable" msprop:Generator_TableVarName="tablegroups" msprop:Generator_TablePropName="groups" msprop:Generator_RowDeletingName="groupsRowDeleting" msprop:Generator_UserTableName="groups" msprop:Generator_RowChangingName="groupsRowChanging" msprop:Generator_RowEvHandlerName="groupsRowChangeEventHandler" msprop:Generator_RowDeletedName="groupsRowDeleted" msprop:Generator_RowEvArgName="groupsRowChangeEvent" msprop:Generator_RowChangedName="groupsRowChanged" msprop:Generator_RowClassName="groupsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title_en" msprop:Generator_ColumnVarNameInTable="columntitle_en" msprop:Generator_ColumnPropNameInRow="title_en" msprop:Generator_ColumnPropNameInTable="title_enColumn" msprop:Generator_UserColumnName="title_en">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title_fr" msprop:Generator_ColumnVarNameInTable="columntitle_fr" msprop:Generator_ColumnPropNameInRow="title_fr" msprop:Generator_ColumnPropNameInTable="title_frColumn" msprop:Generator_UserColumnName="title_fr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="seatreferences" msprop:Generator_TableClassName="seatreferencesDataTable" msprop:Generator_TableVarName="tableseatreferences" msprop:Generator_TablePropName="seatreferences" msprop:Generator_RowDeletingName="seatreferencesRowDeleting" msprop:Generator_UserTableName="seatreferences" msprop:Generator_RowChangingName="seatreferencesRowChanging" msprop:Generator_RowEvHandlerName="seatreferencesRowChangeEventHandler" msprop:Generator_RowDeletedName="seatreferencesRowDeleted" msprop:Generator_RowEvArgName="seatreferencesRowChangeEvent" msprop:Generator_RowChangedName="seatreferencesRowChanged" msprop:Generator_RowClassName="seatreferencesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="seatId" msprop:Generator_ColumnVarNameInTable="columnseatId" msprop:Generator_ColumnPropNameInRow="seatId" msprop:Generator_ColumnPropNameInTable="seatIdColumn" msprop:Generator_UserColumnName="seatId" type="xs:int" />
              <xs:element name="Reference" msprop:Generator_ColumnVarNameInTable="columnReference" msprop:Generator_ColumnPropNameInRow="Reference" msprop:Generator_ColumnPropNameInTable="ReferenceColumn" msprop:Generator_UserColumnName="Reference">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="seatreservations" msprop:Generator_TableClassName="seatreservationsDataTable" msprop:Generator_TableVarName="tableseatreservations" msprop:Generator_TablePropName="seatreservations" msprop:Generator_RowDeletingName="seatreservationsRowDeleting" msprop:Generator_UserTableName="seatreservations" msprop:Generator_RowChangingName="seatreservationsRowChanging" msprop:Generator_RowEvHandlerName="seatreservationsRowChangeEventHandler" msprop:Generator_RowDeletedName="seatreservationsRowDeleted" msprop:Generator_RowEvArgName="seatreservationsRowChangeEvent" msprop:Generator_RowChangedName="seatreservationsRowChanged" msprop:Generator_RowClassName="seatreservationsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="seatId" msprop:Generator_ColumnVarNameInTable="columnseatId" msprop:Generator_ColumnPropNameInRow="seatId" msprop:Generator_ColumnPropNameInTable="seatIdColumn" msprop:Generator_UserColumnName="seatId" type="xs:int" />
              <xs:element name="userId" msprop:Generator_ColumnVarNameInTable="columnuserId" msprop:Generator_ColumnPropNameInRow="userId" msprop:Generator_ColumnPropNameInTable="userIdColumn" msprop:Generator_UserColumnName="userId" type="xs:int" minOccurs="0" />
              <xs:element name="DateTaken" msprop:Generator_ColumnVarNameInTable="columnDateTaken" msprop:Generator_ColumnPropNameInRow="DateTaken" msprop:Generator_ColumnPropNameInTable="DateTakenColumn" msprop:Generator_UserColumnName="DateTaken" type="xs:dateTime" />
              <xs:element name="Hidden" msprop:Generator_ColumnVarNameInTable="columnHidden" msprop:Generator_ColumnPropNameInRow="Hidden" msprop:Generator_ColumnPropNameInTable="HiddenColumn" msprop:Generator_UserColumnName="Hidden" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tickets" msprop:Generator_TableClassName="ticketsDataTable" msprop:Generator_TableVarName="tabletickets" msprop:Generator_TablePropName="tickets" msprop:Generator_RowDeletingName="ticketsRowDeleting" msprop:Generator_UserTableName="tickets" msprop:Generator_RowChangingName="ticketsRowChanging" msprop:Generator_RowEvHandlerName="ticketsRowChangeEventHandler" msprop:Generator_RowDeletedName="ticketsRowDeleted" msprop:Generator_RowEvArgName="ticketsRowChangeEvent" msprop:Generator_RowChangedName="ticketsRowChanged" msprop:Generator_RowClassName="ticketsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnPropNameInTable="user_idColumn" msprop:Generator_UserColumnName="user_id" type="xs:int" />
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" type="xs:int" />
              <xs:element name="txn_id" msprop:Generator_ColumnVarNameInTable="columntxn_id" msprop:Generator_ColumnPropNameInRow="txn_id" msprop:Generator_ColumnPropNameInTable="txn_idColumn" msprop:Generator_UserColumnName="txn_id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="paid" msprop:Generator_ColumnVarNameInTable="columnpaid" msprop:Generator_ColumnPropNameInRow="paid" msprop:Generator_ColumnPropNameInTable="paidColumn" msprop:Generator_UserColumnName="paid" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="transactions" msprop:Generator_TableClassName="transactionsDataTable" msprop:Generator_TableVarName="tabletransactions" msprop:Generator_TablePropName="transactions" msprop:Generator_RowDeletingName="transactionsRowDeleting" msprop:Generator_UserTableName="transactions" msprop:Generator_RowChangingName="transactionsRowChanging" msprop:Generator_RowEvHandlerName="transactionsRowChangeEventHandler" msprop:Generator_RowDeletedName="transactionsRowDeleted" msprop:Generator_RowEvArgName="transactionsRowChangeEvent" msprop:Generator_RowChangedName="transactionsRowChanged" msprop:Generator_RowClassName="transactionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="txn_id" msprop:Generator_ColumnVarNameInTable="columntxn_id" msprop:Generator_ColumnPropNameInRow="txn_id" msprop:Generator_ColumnPropNameInTable="txn_idColumn" msprop:Generator_UserColumnName="txn_id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnPropNameInTable="user_idColumn" msprop:Generator_UserColumnName="user_id" type="xs:int" />
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:Generator_UserColumnName="state">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pp_txn_id" msprop:Generator_ColumnVarNameInTable="columnpp_txn_id" msprop:Generator_ColumnPropNameInRow="pp_txn_id" msprop:Generator_ColumnPropNameInTable="pp_txn_idColumn" msprop:Generator_UserColumnName="pp_txn_id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="actions" msprop:Generator_TableClassName="actionsDataTable" msprop:Generator_TableVarName="tableactions" msprop:Generator_TablePropName="actions" msprop:Generator_RowDeletingName="actionsRowDeleting" msprop:Generator_UserTableName="actions" msprop:Generator_RowChangingName="actionsRowChanging" msprop:Generator_RowEvHandlerName="actionsRowChangeEventHandler" msprop:Generator_RowDeletedName="actionsRowDeleted" msprop:Generator_RowEvArgName="actionsRowChangeEvent" msprop:Generator_RowChangedName="actionsRowChanged" msprop:Generator_RowClassName="actionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnPropNameInTable="user_idColumn" msprop:Generator_UserColumnName="user_id" type="xs:int" />
              <xs:element name="date_action" msprop:Generator_ColumnVarNameInTable="columndate_action" msprop:Generator_ColumnPropNameInRow="date_action" msprop:Generator_ColumnPropNameInTable="date_actionColumn" msprop:Generator_UserColumnName="date_action" type="xs:dateTime" />
              <xs:element name="action" msprop:Generator_ColumnVarNameInTable="columnaction" msprop:Generator_ColumnPropNameInRow="action" msprop:Generator_ColumnPropNameInTable="actionColumn" msprop:Generator_UserColumnName="action">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="commentaires" msprop:Generator_ColumnVarNameInTable="columncommentaires" msprop:Generator_ColumnPropNameInRow="commentaires" msprop:Generator_ColumnPropNameInTable="commentairesColumn" msprop:Generator_UserColumnName="commentaires">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="21845" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:users" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="groups_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:groups" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="seatreferences_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:seatreferences" />
      <xs:field xpath="mstns:seatId" />
    </xs:unique>
    <xs:unique name="seatreservations_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:seatreservations" />
      <xs:field xpath="mstns:seatId" />
    </xs:unique>
    <xs:unique name="tickets_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tickets" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="transactions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:transactions" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_groups_users" msdata:parent="groups" msdata:child="users" msdata:parentkey="id" msdata:childkey="id_group" msprop:Generator_UserChildTable="users" msprop:Generator_ChildPropName="GetusersRows" msprop:Generator_ParentPropName="groupsRow" msprop:Generator_UserRelationName="FK_groups_users" msprop:Generator_RelationVarName="relationFK_groups_users" msprop:Generator_UserParentTable="groups" />
      <msdata:Relationship name="FK_users_tickets" msdata:parent="users" msdata:child="tickets" msdata:parentkey="id" msdata:childkey="user_id" msprop:Generator_UserChildTable="tickets" msprop:Generator_ChildPropName="GetticketsRows" msprop:Generator_ParentPropName="usersRow" msprop:Generator_UserRelationName="FK_users_tickets" msprop:Generator_RelationVarName="relationFK_users_tickets" msprop:Generator_UserParentTable="users" />
      <msdata:Relationship name="FK_users_seatreservations" msdata:parent="users" msdata:child="seatreservations" msdata:parentkey="id" msdata:childkey="userId" msprop:Generator_UserChildTable="seatreservations" msprop:Generator_ChildPropName="GetseatreservationsRows" msprop:Generator_ParentPropName="usersRow" msprop:Generator_UserRelationName="FK_users_seatreservations" msprop:Generator_RelationVarName="relationFK_users_seatreservations" msprop:Generator_UserParentTable="users" />
      <msdata:Relationship name="FK_seatreferences_seatreservations" msdata:parent="seatreferences" msdata:child="seatreservations" msdata:parentkey="seatId" msdata:childkey="seatId" msprop:Generator_UserChildTable="seatreservations" msprop:Generator_ChildPropName="GetseatreservationsRows" msprop:Generator_ParentPropName="seatreferencesRow" msprop:Generator_UserRelationName="FK_seatreferences_seatreservations" msprop:Generator_RelationVarName="relationFK_seatreferences_seatreservations" msprop:Generator_UserParentTable="seatreferences" />
      <msdata:Relationship name="users_transactions" msdata:parent="users" msdata:child="transactions" msdata:parentkey="id" msdata:childkey="user_id" msprop:Generator_UserChildTable="transactions" msprop:Generator_ChildPropName="GettransactionsRows" msprop:Generator_UserParentTable="users" msprop:Generator_UserRelationName="users_transactions" msprop:Generator_RelationVarName="relationusers_transactions" msprop:Generator_ParentPropName="usersRow" />
      <msdata:Relationship name="tickets_transactions" msdata:parent="transactions" msdata:child="tickets" msdata:parentkey="txn_id" msdata:childkey="txn_id" msprop:Generator_UserChildTable="tickets" msprop:Generator_ChildPropName="GetticketsRows" msprop:Generator_UserParentTable="transactions" msprop:Generator_UserRelationName="tickets_transactions" msprop:Generator_RelationVarName="relationtickets_transactions" msprop:Generator_ParentPropName="transactionsRow" />
      <msdata:Relationship name="users_actions" msdata:parent="users" msdata:child="actions" msdata:parentkey="id" msdata:childkey="user_id" msprop:Generator_UserChildTable="actions" msprop:Generator_ChildPropName="GetactionsRows" msprop:Generator_ParentPropName="usersRow" msprop:Generator_UserRelationName="users_actions" msprop:Generator_RelationVarName="relationusers_actions" msprop:Generator_UserParentTable="users" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>